IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = object_id(N'[dbo].[DeleteDetallePedido]') AND OBJECTPROPERTY(id, N'IsProcedure') = 1)
	DROP PROCEDURE [dbo].[DeleteDetallePedido]
GO

CREATE PROCEDURE [dbo].[DeleteDetallePedido]
(
	@IdPedido int,
	@IdProducto int
)
AS
BEGIN
	SET NOCOUNT ON

	DELETE FROM [DetallePedido]
	WHERE [IdPedido] = @IdPedido AND [IdProducto] = @IdProducto

	SET NOCOUNT OFF
END

GO
